﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace ExtendBLL
{
   public class ClassItem
    {
       public DataSet GetListByTeaMisID(int ID)
       {
           string str = "select ID,Class_Code,Class_Name,Class_StudentNum,(select Pro_Name from Professional where Class.Class_Professional=Professional.ID) as Class_Professional from Class where Class.[ID] in (select distinct ClassID from ClassItem where TeachMissionID="+ID+")";
           DataSet ds = new DataSet();
           ds = Maticsoft.DBUtility.DbHelperSQL.Query(str);
           return ds;
       }
    }
}
